Pandas Profiling Report

Dataset statistics

Number of variables	12
Number of observations	364
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	34.2 KiB
Average record size in memory	96.4 B

Variable types

Numeric	11
Categorical	1

Warnings

`df_index` is uniformly distributed	Uniform
`df_index` has unique values	Unique

Reproduction

Analysis started	2021-04-27 05:44:29.583248
Analysis finished	2021-04-27 05:46:35.724246
Duration	2 minutes and 6.14 seconds
Software version	pandas-profiling v2.11.0
Download configuration	config.yaml

df_index
Real number (ℝ_≥0)

UNIFORM
UNIQUE

Distinct	364
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	182.5
Minimum	1
Maximum	364
Zeros	0
Zeros (%)	0.0%
Memory size	3.0 KiB

Quantile statistics

Minimum	1
5-th percentile	19.15
Q1	91.75
median	182.5
Q3	273.25
95-th percentile	345.85
Maximum	364
Range	363
Interquartile range (IQR)	181.5

Descriptive statistics

Standard deviation	105.2219876
Coefficient of variation (CV)	0.576558836
Kurtosis	-1.2
Mean	182.5
Median Absolute Deviation (MAD)	91
Skewness	0
Sum	66430
Variance	11071.66667
Monotocity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	0.3%
251	1	0.3%
249	1	0.3%
248	1	0.3%
247	1	0.3%
246	1	0.3%
245	1	0.3%
244	1	0.3%
243	1	0.3%
242	1	0.3%
Other values (354)	354	97.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	0.3%
2	1	0.3%
3	1	0.3%
4	1	0.3%
5	1	0.3%

Value	Count	Frequency (%)
364	1	0.3%
363	1	0.3%
362	1	0.3%
361	1	0.3%
360	1	0.3%

Age
Real number (ℝ_≥0)

Distinct	73
Distinct (%)	20.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	44.91758242
Minimum	11
Maximum	89
Zeros	0
Zeros (%)	0.0%
Memory size	3.0 KiB

Quantile statistics

Minimum	11
5-th percentile	16
Q1	28
median	44.5
Q3	60
95-th percentile	75.85
Maximum	89
Range	78
Interquartile range (IQR)	32

Descriptive statistics

Standard deviation	18.78085358
Coefficient of variation (CV)	0.4181180859
Kurtosis	-1.011961372
Mean	44.91758242
Median Absolute Deviation (MAD)	15.5
Skewness	0.1470426138
Sum	16350
Variance	352.7204614
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
65	18	4.9%
35	16	4.4%
57	15	4.1%
60	13	3.6%
28	13	3.6%
27	12	3.3%
24	11	3.0%
55	11	3.0%
30	10	2.7%
38	10	2.7%
Other values (63)	235	64.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
11	1	0.3%
12	1	0.3%
13	5	1.4%
14	7	1.9%
15	3	0.8%

Value	Count	Frequency (%)
89	1	0.3%
87	1	0.3%
83	2	0.5%
81	2	0.5%
80	6	1.6%

Sex
Categorical

Distinct	2
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	3.0 KiB

0.0	203
1.0	161

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	1092
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	1.0
4th row	0.0
5th row	1.0

Value	Count	Frequency (%)
0.0	203	55.8%
1.0	161	44.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
0.0	203	55.8%
1.0	161	44.2%

Most occurring characters

Value	Count	Frequency (%)
0	567	51.9%
.	364	33.3%
1	161	14.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	728	66.7%
Other Punctuation	364	33.3%

Most frequent character per category

Value	Count	Frequency (%)
0	567	77.9%
1	161	22.1%

Value	Count	Frequency (%)
.	364	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1092	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	567	51.9%
.	364	33.3%
1	161	14.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1092	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	567	51.9%
.	364	33.3%
1	161	14.7%

PCV
Real number (ℝ_≥0)

Distinct	188
Distinct (%)	51.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	36.76291209
Minimum	13.1
Maximum	56.9
Zeros	0
Zeros (%)	0.0%
Memory size	3.0 KiB

Quantile statistics

Minimum	13.1
5-th percentile	25.015
Q1	32.9
median	36.8
Q3	41.85
95-th percentile	47.285
Maximum	56.9
Range	43.8
Interquartile range (IQR)	8.95

Descriptive statistics

Standard deviation	6.830834586
Coefficient of variation (CV)	0.1858077665
Kurtosis	0.4699496764
Mean	36.76291209
Median Absolute Deviation (MAD)	4.6
Skewness	-0.3661237376
Sum	13381.7
Variance	46.66030114
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
33.1	7	1.9%
32.9	6	1.6%
36.8	5	1.4%
33.2	5	1.4%
35	5	1.4%
27.4	4	1.1%
39.7	4	1.1%
42.3	4	1.1%
43.2	4	1.1%
34.8	4	1.1%
Other values (178)	316	86.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
13.1	2	0.5%
16.6	1	0.3%
16.7	1	0.3%
17.5	1	0.3%
20	1	0.3%

Value	Count	Frequency (%)
56.9	1	0.3%
52.2	1	0.3%
51.7	1	0.3%
50	1	0.3%
49.6	3	0.8%

MCV
Real number (ℝ_≥0)

Distinct	200
Distinct (%)	54.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	87.50912088
Minimum	55.7
Maximum	124.1
Zeros	0
Zeros (%)	0.0%
Memory size	3.0 KiB

Quantile statistics

Minimum	55.7
5-th percentile	73.315
Q1	83.175
median	87.95
Q3	91.875
95-th percentile	102.135
Maximum	124.1
Range	68.4
Interquartile range (IQR)	8.7

Descriptive statistics

Standard deviation	9.332164102
Coefficient of variation (CV)	0.1066421878
Kurtosis	2.663400254
Mean	87.50912088
Median Absolute Deviation (MAD)	4.45
Skewness	0.1382931144
Sum	31853.32
Variance	87.08928683
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
89.2	9	2.5%
88.1	7	1.9%
87.8	7	1.9%
94.9	5	1.4%
85.6	5	1.4%
88.9	4	1.1%
86	4	1.1%
90.1	4	1.1%
91.3	4	1.1%
90.4	4	1.1%
Other values (190)	311	85.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
55.7	1	0.3%
57.3	1	0.3%
58.5	1	0.3%
60.1	1	0.3%
62.1	1	0.3%

Value	Count	Frequency (%)
124.1	1	0.3%
122.1	1	0.3%
119	2	0.5%
117.3	1	0.3%
113.8	1	0.3%

MCH
Real number (ℝ_≥0)

Distinct	140
Distinct (%)	38.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	28.22714286
Minimum	14.7
Maximum	41.4
Zeros	0
Zeros (%)	0.0%
Memory size	3.0 KiB

Quantile statistics

Minimum	14.7
5-th percentile	21.715
Q1	26.3
median	28.2
Q3	30.4
95-th percentile	34.2
Maximum	41.4
Range	26.7
Interquartile range (IQR)	4.1

Descriptive statistics

Standard deviation	3.865998148
Coefficient of variation (CV)	0.1369603069
Kurtosis	1.647355844
Mean	28.22714286
Median Absolute Deviation (MAD)	2
Skewness	0.02165163326
Sum	10274.68
Variance	14.94594168
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28.8	12	3.3%
27	9	2.5%
29.9	7	1.9%
30.4	7	1.9%
27.6	7	1.9%
26.7	7	1.9%
26.8	6	1.6%
27.2	6	1.6%
28.4	6	1.6%
27.3	6	1.6%
Other values (130)	291	79.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
14.7	1	0.3%
15.8	1	0.3%
17	1	0.3%
17.7	2	0.5%
18.6	1	0.3%

Value	Count	Frequency (%)
41.4	1	0.3%
41.2	2	0.5%
40.1	1	0.3%
39.1	1	0.3%
38.2	1	0.3%

MCHC
Real number (ℝ_≥0)

Distinct	102
Distinct (%)	28.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	32.05340659
Minimum	23.6
Maximum	50.2
Zeros	0
Zeros (%)	0.0%
Memory size	3.0 KiB

Quantile statistics

Minimum	23.6
5-th percentile	28.7
Q1	30.3
median	31.7
Q3	33.3
95-th percentile	38
Maximum	50.2
Range	26.6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.801790443
Coefficient of variation (CV)	0.08741006778
Kurtosis	5.441354479
Mean	32.05340659
Median Absolute Deviation (MAD)	1.5
Skewness	1.399070172
Sum	11667.44
Variance	7.850029685
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30.3	10	2.7%
32.4	10	2.7%
31.3	9	2.5%
33.9	9	2.5%
32.1	9	2.5%
30.2	8	2.2%
31	8	2.2%
30.6	7	1.9%
31.2	7	1.9%
32.6	7	1.9%
Other values (92)	280	76.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
23.6	1	0.3%
25.5	1	0.3%
26.3	1	0.3%
26.4	1	0.3%
26.7	1	0.3%

Value	Count	Frequency (%)
50.2	1	0.3%
42	1	0.3%
41	1	0.3%
40.2	1	0.3%
39.6	1	0.3%

RDW
Real number (ℝ_≥0)

Distinct	83
Distinct (%)	22.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	15.11651099
Minimum	10.6
Maximum	29.2
Zeros	0
Zeros (%)	0.0%
Memory size	3.0 KiB

Quantile statistics

Minimum	10.6
5-th percentile	12.7
Q1	13.6
median	14.8
Q3	16.1
95-th percentile	18.585
Maximum	29.2
Range	18.6
Interquartile range (IQR)	2.5

Descriptive statistics

Standard deviation	2.176557337
Coefficient of variation (CV)	0.1439854302
Kurtosis	7.457132928
Mean	15.11651099
Median Absolute Deviation (MAD)	1.2
Skewness	1.960530992
Sum	5502.41
Variance	4.737401843
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13.1	12	3.3%
13.3	11	3.0%
16.1	11	3.0%
13.6	11	3.0%
14.2	10	2.7%
13.9	10	2.7%
12.9	10	2.7%
14.9	10	2.7%
14.7	10	2.7%
14.6	9	2.5%
Other values (73)	260	71.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10.6	1	0.3%
11.3	1	0.3%
11.4	1	0.3%
11.8	1	0.3%
12.1	1	0.3%

Value	Count	Frequency (%)
29.2	1	0.3%
25	2	0.5%
24.6	1	0.3%
22.5	1	0.3%
21.3	2	0.5%

TLC
Real number (ℝ_≥0)

Distinct	237
Distinct (%)	65.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	8.863571429
Minimum	2
Maximum	42.42
Zeros	0
Zeros (%)	0.0%
Memory size	3.0 KiB

Quantile statistics

Minimum	2
5-th percentile	4.2
Q1	5.9
median	7.935
Q3	10.205
95-th percentile	16.8625
Maximum	42.42
Range	40.42
Interquartile range (IQR)	4.305

Descriptive statistics

Standard deviation	4.868502227
Coefficient of variation (CV)	0.5492709418
Kurtosis	14.0015884
Mean	8.863571429
Median Absolute Deviation (MAD)	2.065
Skewness	2.941297674
Sum	3226.34
Variance	23.70231393
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8.4	6	1.6%
7.6	5	1.4%
4.5	5	1.4%
6.3	5	1.4%
9.2	5	1.4%
8.1	4	1.1%
6.7	4	1.1%
4.7	4	1.1%
9.1	4	1.1%
6.2	4	1.1%
Other values (227)	318	87.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	1	0.3%
2.4	1	0.3%
2.6	2	0.5%
2.88	2	0.5%
3	1	0.3%

Value	Count	Frequency (%)
42.42	1	0.3%
41.9	1	0.3%
32.72	1	0.3%
28.03	1	0.3%
26.95	1	0.3%

PLT/mm3
Real number (ℝ_≥0)

Distinct	208
Distinct (%)	57.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	223.7508242
Minimum	10
Maximum	660
Zeros	0
Zeros (%)	0.0%
Memory size	3.0 KiB

Quantile statistics

Minimum	10
5-th percentile	90
Q1	153
median	210
Q3	268.25
95-th percentile	414.45
Maximum	660
Range	650
Interquartile range (IQR)	115.25

Descriptive statistics

Standard deviation	99.40715299
Coefficient of variation (CV)	0.4442761422
Kurtosis	1.636288181
Mean	223.7508242
Median Absolute Deviation (MAD)	57
Skewness	0.9965530766
Sum	81445.3
Variance	9881.782065
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
150	15	4.1%
140	8	2.2%
153	7	1.9%
152	6	1.6%
151	5	1.4%
222	5	1.4%
233	5	1.4%
158	4	1.1%
188	4	1.1%
90	4	1.1%
Other values (198)	301	82.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10	1	0.3%
24	1	0.3%
32	2	0.5%
35	1	0.3%
36	1	0.3%

Value	Count	Frequency (%)
660	1	0.3%
589	1	0.3%
534	2	0.5%
532	1	0.3%
510	1	0.3%

HGB
Real number (ℝ_≥0)

Distinct	84
Distinct (%)	23.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	11.90769231
Minimum	4.2
Maximum	19.6
Zeros	0
Zeros (%)	0.0%
Memory size	3.0 KiB

Quantile statistics

Minimum	4.2
5-th percentile	8.1
Q1	10.6
median	12.1
Q3	13.4
95-th percentile	15.085
Maximum	19.6
Range	15.4
Interquartile range (IQR)	2.8

Descriptive statistics

Standard deviation	2.186685519
Coefficient of variation (CV)	0.1836363808
Kurtosis	0.7180330655
Mean	11.90769231
Median Absolute Deviation (MAD)	1.35
Skewness	-0.4887965063
Sum	4334.4
Variance	4.781593558
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13.4	12	3.3%
11.2	11	3.0%
13.1	11	3.0%
11.3	10	2.7%
12.9	10	2.7%
11	9	2.5%
13.9	9	2.5%
12	9	2.5%
11.9	9	2.5%
12.7	8	2.2%
Other values (74)	266	73.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4.2	2	0.5%
5	1	0.3%
5.2	1	0.3%
6.1	1	0.3%
6.9	2	0.5%

Value	Count	Frequency (%)
19.6	1	0.3%
16.2	1	0.3%
16	2	0.5%
15.9	3	0.8%
15.6	3	0.8%

RBC
Real number (ℝ_≥0)

Distinct	195
Distinct (%)	53.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4.278736264
Minimum	1.36
Maximum	6.9
Zeros	0
Zeros (%)	0.0%
Memory size	3.0 KiB

Quantile statistics

Minimum	1.36
5-th percentile	2.8975
Q1	3.78
median	4.335
Q3	4.8
95-th percentile	5.547
Maximum	6.9
Range	5.54
Interquartile range (IQR)	1.02

Descriptive statistics

Standard deviation	0.8201663116
Coefficient of variation (CV)	0.1916842406
Kurtosis	0.7949632884
Mean	4.278736264
Median Absolute Deviation (MAD)	0.5
Skewness	-0.3284202011
Sum	1557.46
Variance	0.6726727787
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.47	6	1.6%
4.1	6	1.6%
4.86	5	1.4%
4.33	5	1.4%
4.61	4	1.1%
4.12	4	1.1%
4.54	4	1.1%
4.65	4	1.1%
3.51	4	1.1%
3.96	4	1.1%
Other values (185)	318	87.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.36	1	0.3%
1.91	2	0.5%
1.92	1	0.3%
1.96	1	0.3%
2.17	1	0.3%

Value	Count	Frequency (%)
6.9	1	0.3%
6.6	1	0.3%
6.58	1	0.3%
6.05	2	0.5%
5.94	1	0.3%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	Age	Sex	PCV	MCV	MCH	MCHC	RDW	TLC	PLT/mm3	HGB	RBC
0	1	28.0	0.0	34	60.1	17	28.2	20	11.1	128.3	9.6	5.66
1	2	41.0	0.0	44.5	93.1	28.9	31.0	13	7.02	419	13.8	4.78
2	3	40.0	1.0	41.6	89.5	28.8	32.2	13	8.09	325	13.4	4.65
3	4	76.0	0.0	36.7	86.6	26.7	30.8	14.9	13.41	264	11.3	4.24
4	5	20.0	1.0	36.9	89.1	27.8	31.2	13.2	4.75	196	11.5	4.14
5	6	24.0	0.0	40.1	93.5	29.6	31.7	14.5	13.96	233	12.7	4.29
6	7	28.0	1.0	42.3	84.9	24.9	29.3	16.2	9.33	213	12.4	4.98
7	8	14.0	0.0	43.8	88.1	28	31.7	15.2	3.92	229	13.9	4.97
8	9	16.0	0.0	38.7	93	28.8	31.0	17.9	5.77	211	12	4.16
9	10	62.0	0.0	45.6	86.9	25.3	29.2	15.6	10.68	151	13.3	5.25

Last rows

	df_index	Age	Sex	PCV	MCV	MCH	MCHC	RDW	TLC	PLT/mm3	HGB	RBC
354	355	46.0	0.0	42.9	90.1	30.2	33.5	13.1	7.2	244	14.4	4.76
355	356	25.0	1.0	37.5	93.7	32.3	34.5	17.4	6.7	312	12.9	4
356	357	24.0	0.0	35.7	76.6	26.2	34.1	13.7	8.7	266	12.2	4.66
357	358	28.0	0.0	30.7	89.7	28.7	32.0	19	7.7	457	9.8	3.42
358	359	22.0	0.0	29.1	62.6	20.4	32.6	17	6.7	200	9.5	4.65
359	360	17.0	0.0	39.2	80.7	27.7	34.4	13.4	4.4	180	13.5	4.86
360	361	51.0	0.0	35.2	91.7	31	33.8	13.3	5.6	215	15	4.85
361	362	21.0	1.0	39.7	88.7	29.3	33.0	13.5	9.2	329	13.1	4.47
362	363	35.0	1.0	36.2	86.7	27.9	32.1	13.5	6.48	174	13.2	4.75
363	364	26.0	0.0	44.4	89.7	30.6	34.2	12.3	8.8	279	15.2	4.95

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows